#数据分组统计
import numpy as np
import pandas as pd
pd.set_option('display.unicode.east_asian_width',True)
df = pd.read_excel('D:/ITaudit/pandas_excel/Orders.xlsx')
df['numbers'] = np.random.randint(140, 600,size=121317)#在df中增加一列随机数
df.to_excel('D:/ITaudit/pandas_excel/Orders1.xlsx')
print('done')
# df1 = df[['Total','Category']]
# print(df1)


